package com.sky.mapper;

import com.sky.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

@Mapper
public interface UserMapper {
	
	/**
	 * 根据openid查询用户
	 * @param openid
	 * @return
	 */
	@Select("SELECT * FROM user WHERE openid = #{openid} LIMIT 1")
	User getByOpenid(String openid);
	
	/**
	 * 插入数据
	 * @param user
	 */
	void insert(User user);
	@Select("SELECT * FROM user WHERE id = #{id}")
	User getById(Long userId);
	
	/**
	 * 根据动态条件统计用户数量
	 * @param map
	 * @return
	 */
	Integer countByMap(Map map);
}
